# Frierson, Dylan, Lab 2
# 1
SELECT CONCAT(FirstName, ' ', LastName) AS 'Customer Name', State 
FROM customers
WHERE State = 'NJ';
# 2
SELECT OrderNum, ShipDate 
FROM Orders
WHERE ShipDate >'2003-04-01';
# 3
SELECT Title, Category
FROM books
WHERE NOT Category = 'FITNESS';
# 4
SELECT CONCAT(FirstName, ' ', LastName) AS 'Customer Name', State
FROM Customers
WHERE (State = 'GA' OR State = "NJ")
Order By LastName;
# 5
SELECT OrderNum, OrderDate, ShipDate, (TO_DAYS(ShipDate)-TO_DAYS(OrderDate)) AS 'Processing Days'
FROM Orders;
# 6
SELECT Lname, Fname
FROM author
WHERE Lname LIKE '%IN%'
Order By Lname DESC;
# 7
SELECT CONCAT(FirstName, ' ', LastName) AS 'Referred Customers'
FROM Customers
WHERE NOT Referred IS NULL;
# 8
SELECT Title, Category
FROM Books
WHERE Category LIKE 'C_%i%';
# 9
SELECT Title
FROM Books
WHERE Title LIKE '_A_N%';
# 10
SELECT Title, PubDate
FROM Books
WHERE Category = 'Computer' AND PubDate BETWEEN '2001-01-01' AND "2001-12-31";